﻿using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

namespace WebApplication1.Conexao
{
    public class ConexaoBD
    {
        public ConexaoBD() { }

        private SqlConnection conexaoBD;

        public SqlConnection RealizarConexaoBD()
        {
            try
            {
                String strConexaoBD = "Data Source = localhost; Initial Catalog = NorthWind; user = sa; password = senha";
                conexaoBD = new SqlConnection(strConexaoBD);
                conexaoBD.Open();
                return conexaoBD;
            }

            catch (SqlException exception)
            {
                Console.WriteLine(exception.Message);
                return null;
            }


        }

        public void EncerrarConexaoBD() 
        {
            try
            {
                if (conexaoBD != null)
                {
                    conexaoBD.Close();
                }

            }

            catch (SqlException exception)
            {
                Console.WriteLine(exception.Message);
            }

        }



    }

}
